Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NLS_DATE_FORMAT

Property | Description
--- | ---
Parameter type | String
Syntax | `NLS_DATE_FORMAT = "``format``"`
Default value | Derived from `NLS_TERRITORY`
Modifiable | `ALTER SESSION`
Range of values | Any valid date format mask but not exceeding a fixed length
Basic | No

`NLS_DATE_FORMAT` specifies the default date format to use with the `TO_CHAR` and `TO_DATE` functions. The default value of this parameter is determined by `NLS_TERRITORY`.

The value of this parameter can be any valid date format mask, and the value must be surrounded by double quotation marks. For example:

    NLS_DATE_FORMAT = "MM/DD/YYYY"

See Also: Oracle Database Globalization Support Guide for more information on setting this parameter Oracle Database Heterogeneous Connectivity Administrator's Guide for information on setting this parameter in heterogeneous systems